USE [Training]
GO

IF NOT EXISTS (SELECT * from dbo.sysobjects WHERE id = OBJECT_ID(N'dbo.training_api_EmployeePasswordChange'))
	EXEC('CREATE PROC dbo.training_api_EmployeePasswordChange AS')
GO

ALTER PROC dbo.training_api_EmployeePasswordChange
	@EmployeeID	int,
	@Password	nvarchar(max)
AS
	UPDATE Employee
	SET Password = @Password
	WHERE EmployeeID = @EmployeeID